﻿CREATE TABLE [dbo].[t_PublicRecord] (
    [ID]                               INT           IDENTITY (1, 1) NOT NULL,
    [BorrowerID]                       INT           NULL,
    [CoBorrowerID]                     INT           NULL,
    [CreditPublicRecordID]             VARCHAR (128) NULL,
    [CreditFileID]                     VARCHAR (128) NULL,
    [_DerogatoryDataIndicator]         VARCHAR (128) NULL,
    [_CourtName]                       VARCHAR (128) NULL,
    [_BankruptcyAssetsAmount]          INT           NULL,
    [_BankruptcyLiabilitiesAmount]     INT           NULL,
    [_DispositionType]                 VARCHAR (128) NULL,
    [_DispositionDate]                 SMALLDATETIME NULL,
    [_DispositionTypeOtherDescription] VARCHAR (128) NULL,
    [_DocketIdentifier]                VARCHAR (128) NULL,
    [_FiledDate]                       SMALLDATETIME NULL,
    [_LegalObligationAmount]           INT           NULL,
    [_PlaintiffName]                   VARCHAR (128) NULL,
    [_ReportedDate]                    SMALLDATETIME NULL,
    [_Type]                            VARCHAR (128) NULL,
    [_TypeOtherDescription]            VARCHAR (128) NULL,
    [CREDIT_COMMENT_Text]              VARCHAR (512) NULL
);

